﻿CREATE TABLE [dbo].[UserDealerAddress_tbl] (
    [DealerAddressID] INT            IDENTITY (1, 1) NOT NULL,
    [Department]      NVARCHAR (50)  NULL,
    [Company]         NVARCHAR (255) NULL,
    [Line1]           NVARCHAR (50)  NULL,
    [Line2]           NVARCHAR (50)  NULL,
    [Line3]           NVARCHAR (50)  NULL,
    [Line4]           NVARCHAR (50)  NULL,
    [CountryID]       INT            NULL,
    [MainPhone]       NVARCHAR (50)  NULL,
    [MainFax]         NVARCHAR (50)  NULL,
    [MainEmail]       NVARCHAR (50)  NULL,
    [MainWWW]         NVARCHAR (50)  NULL,
    [Bank]            NVARCHAR (MAX) NULL,
    [RegNo]           NVARCHAR (MAX) NULL
);

